package daoClasses;
import beanClasses.*;

public class Query 
{
	//static String ind_user="insert into Acc_Holder(Acc_Holder_ID,f_name,m_name,l_name,dob,indian_citizen,address,phn,email,pan,demat,pwd,status,reason)values('IU'|| IndividualUser_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?)";;
	//static String login="select Acc_holder,pwd from Acc_Holder";
	
	
	public String insertIU(IndividualUser iu)
	{
		String ind_user="insert into Acc_Holder(Acc_Holder_ID,f_name,m_name,l_name,dob,indian_citizen,address,phn,email,pan,demat,pwd,status,reason)values('IU'|| IndividualUser_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		return ind_user;
	}
	
	public String loginUser(String uname)
	{
		String login="select Acc_holder_id,pwd,f_name from Acc_Holder where Acc_holder_id='"+uname+"'";
		return login;
	}
	
	public String iuProfile(String id)
	{
		String profile="select Acc_Holder_ID,f_name,m_name,l_name,dob,indian_citizen,address,phn,email,pan,demat,gender from Acc_Holder where Acc_holder_id='"+id+"'";
		return profile;
	}
}
